create table gen_table
(
    table_id          bigint identity
        constraint PK__gen_tabl__B21E8F24FB39D57C
            primary key,
    table_name        nvarchar(200)
        constraint DF_gen_table_table_name default '',
    table_comment     nvarchar(500)
        constraint DF_gen_table_table_comment default '',
    sub_table_name    nvarchar(64),
    sub_table_fk_name nvarchar(64),
    class_name        nvarchar(100)
        constraint DF_gen_table_class_name default '',
    tpl_category      nvarchar(200)
        constraint DF_gen_table_tpl_category default 'crud',
    package_name      nvarchar(100),
    module_name       nvarchar(30),
    business_name     nvarchar(30),
    function_name     nvarchar(50),
    function_author   nvarchar(50),
    gen_type          nchar
        constraint DF_gen_table_gen_type default '0',
    gen_path          nvarchar(200)
        constraint DF_gen_table_gen_path default '/',
    options           nvarchar(1000),
    create_by         nvarchar(64)
        constraint DF_gen_table_create_by default '',
    create_time       datetime2(0),
    update_by         nvarchar(64)
        constraint DF_gen_table_update_by default '',
    update_time       datetime2(0),
    remark            nvarchar(500)
)
go

exec sp_addextendedproperty 'MS_Description', '代码生成业务表', 'SCHEMA', 'dbo', 'TABLE', 'gen_table'
go

exec sp_addextendedproperty 'MS_Description', '编号', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN', 'table_id'
go

exec sp_addextendedproperty 'MS_Description', '表名称', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN', 'table_name'
go

exec sp_addextendedproperty 'MS_Description', '表描述', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN', 'table_comment'
go

exec sp_addextendedproperty 'MS_Description', '关联子表的表名', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN',
     'sub_table_name'
go

exec sp_addextendedproperty 'MS_Description', '子表关联的外键名', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN',
     'sub_table_fk_name'
go

exec sp_addextendedproperty 'MS_Description', '实体类名称', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN', 'class_name'
go

exec sp_addextendedproperty 'MS_Description', '使用的模板（crud单表操作 tree树表操作）', 'SCHEMA', 'dbo', 'TABLE', 'gen_table',
     'COLUMN', 'tpl_category'
go

exec sp_addextendedproperty 'MS_Description', '生成包路径', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN', 'package_name'
go

exec sp_addextendedproperty 'MS_Description', '生成模块名', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN', 'module_name'
go

exec sp_addextendedproperty 'MS_Description', '生成业务名', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN', 'business_name'
go

exec sp_addextendedproperty 'MS_Description', '生成功能名', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN', 'function_name'
go

exec sp_addextendedproperty 'MS_Description', '生成功能作者', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN',
     'function_author'
go

exec sp_addextendedproperty 'MS_Description', '生成代码方式（0zip压缩包 1自定义路径）', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN',
     'gen_type'
go

exec sp_addextendedproperty 'MS_Description', '生成路径（不填默认项目路径）', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN',
     'gen_path'
go

exec sp_addextendedproperty 'MS_Description', '其它生成选项', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN', 'options'
go

exec sp_addextendedproperty 'MS_Description', '创建者', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN', 'create_by'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN', 'create_time'
go

exec sp_addextendedproperty 'MS_Description', '更新者', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN', 'update_by'
go

exec sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN', 'update_time'
go

exec sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 'gen_table', 'COLUMN', 'remark'
go

INSERT INTO [ry-vue].dbo.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (2, N'hr_user_cv', N'用户信息表-履历表', null, null, N'HrUserCv', N'crud', N'com.ruoyi.system', N'system', N'cv', N'用户信息-履历', N'ruoyi', N'0', N'/', N'{}', N'admin', N'2022-02-28 11:50:54', N'', N'2022-02-28 14:32:33', null);
INSERT INTO [ry-vue].dbo.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (3, N'hr_user', N'用户信息表-附表', N'hr_user_cv', N'fk_hr_user_uuid', N'HrUser', N'sub', N'com.ruoyi.hr', N'hr', N'hrUser', N'用户-附表', N'ruoyi', N'0', N'/', N'{"parentMenuId":"1061"}', N'admin', N'2022-02-28 12:02:28', N'', N'2022-02-28 15:17:58', null);